Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 627868 |
| Missing cells | 1098738 |
| Missing cells (%) | 8.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 95.8 MiB |
| Average record size in memory | 160.0 B |
Variable types
| Categorical | 10 |
|---|---|
| Numeric | 7 |
| Unsupported | 2 |
| Boolean | 1 |
State has constant value "Cross River" | Constant |
Regimen has a high cardinality: 88 distinct values | High cardinality |
PHARMACY_ID is highly correlated with PATIENT_ID and 1 other fields | High correlation |
PATIENT_ID is highly correlated with PHARMACY_ID and 1 other fields | High correlation |
FACILITY_ID is highly correlated with PHARMACY_ID and 1 other fields | High correlation |
AFTERNOON is highly correlated with EVENING | High correlation |
EVENING is highly correlated with AFTERNOON | High correlation |
PHARMACY_ID is highly correlated with PATIENT_ID | High correlation |
PATIENT_ID is highly correlated with PHARMACY_ID and 1 other fields | High correlation |
FACILITY_ID is highly correlated with PATIENT_ID | High correlation |
PATIENT_ID is highly correlated with FACILITY_ID | High correlation |
FACILITY_ID is highly correlated with PATIENT_ID | High correlation |
DMOC_TYPE is highly correlated with PHARMACY_ID and 1 other fields | High correlation |
FACILITY_ID is highly correlated with PHARMACY_ID and 3 other fields | High correlation |
ADHERENCE is highly correlated with Regimen | High correlation |
PHARMACY_ID is highly correlated with DMOC_TYPE and 4 other fields | High correlation |
Regimen Line is highly correlated with Regimen | High correlation |
L.G.A is highly correlated with FACILITY_ID and 3 other fields | High correlation |
Regimen is highly correlated with ADHERENCE and 2 other fields | High correlation |
EVENING is highly correlated with AFTERNOON and 1 other fields | High correlation |
AFTERNOON is highly correlated with EVENING and 1 other fields | High correlation |
PATIENT_ID is highly correlated with FACILITY_ID and 3 other fields | High correlation |
Facility Name is highly correlated with DMOC_TYPE and 4 other fields | High correlation |
MORNING is highly correlated with EVENING and 1 other fields | High correlation |
ADR_IDS is highly correlated with Regimen | High correlation |
ADR_SCREENED has 10322 (1.6%) missing values | Missing |
ADR_IDS has 627858 (> 99.9%) missing values | Missing |
DMOC_TYPE has 460552 (73.4%) missing values | Missing |
DURATION is highly skewed (γ1 = 606.5115674) | Skewed |
MORNING is highly skewed (γ1 = 148.0439747) | Skewed |
EVENING is highly skewed (γ1 = 324.8214677) | Skewed |
BODY_WEIGHT is highly skewed (γ1 = 138.7964098) | Skewed |
PHARMACY_ID has unique values | Unique |
DATE_VISIT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
NEXT_APPOINTMENT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MORNING has 225607 (35.9%) zeros | Zeros |
EVENING has 199008 (31.7%) zeros | Zeros |
BODY_WEIGHT has 625049 (99.6%) zeros | Zeros |
Reproduction
| Analysis started | 2021-06-15 08:56:22.296203 |
|---|---|
| Analysis finished | 2021-06-15 08:57:40.913466 |
| Duration | 1 minute and 18.62 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| Cross River |
|---|
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 6906548 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cross River |
|---|---|
| 2nd row | Cross River |
| 3rd row | Cross River |
| 4th row | Cross River |
| 5th row | Cross River |
Common Values
| Value | Count | Frequency (%) |
| Cross River | 627868 |
Length
Pie chart
| Value | Count | Frequency (%) |
| cross | 627868 | |
| river | 627868 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 1255736 | |
| s | 1255736 | |
| C | 627868 | |
| o | 627868 | |
| 627868 | ||
| R | 627868 | |
| i | 627868 | |
| v | 627868 | |
| e | 627868 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5022944 | |
| Uppercase Letter | 1255736 | 18.2% |
| Space Separator | 627868 | 9.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 1255736 | |
| s | 1255736 | |
| o | 627868 | |
| i | 627868 | |
| v | 627868 | |
| e | 627868 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 627868 | |
| R | 627868 |
Space Separator
| Value | Count | Frequency (%) |
| 627868 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6278680 | |
| Common | 627868 | 9.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 1255736 | |
| s | 1255736 | |
| C | 627868 | |
| o | 627868 | |
| R | 627868 | |
| i | 627868 | |
| v | 627868 | |
| e | 627868 |
Common
| Value | Count | Frequency (%) |
| 627868 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6906548 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 1255736 | |
| s | 1255736 | |
| C | 627868 | |
| o | 627868 | |
| 627868 | ||
| R | 627868 | |
| i | 627868 | |
| v | 627868 | |
| e | 627868 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| Ogoja | |
|---|---|
| Obudu | |
| Obanliku | |
| Yala |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.220433276 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3277743 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Obudu |
|---|---|
| 2nd row | Obudu |
| 3rd row | Obudu |
| 4th row | Obudu |
| 5th row | Obudu |
Common Values
| Value | Count | Frequency (%) |
| Ogoja | 367647 | |
| Obudu | 143668 | 22.9% |
| Obanliku | 63739 | 10.2% |
| Yala | 52814 | 8.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| ogoja | 367647 | |
| obudu | 143668 | 22.9% |
| obanliku | 63739 | 10.2% |
| yala | 52814 | 8.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 575054 | |
| a | 537014 | |
| g | 367647 | |
| o | 367647 | |
| j | 367647 | |
| u | 351075 | |
| b | 207407 | 6.3% |
| d | 143668 | 4.4% |
| l | 116553 | 3.6% |
| n | 63739 | 1.9% |
| Other values (3) | 180292 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2649875 | |
| Uppercase Letter | 627868 | 19.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 537014 | |
| g | 367647 | |
| o | 367647 | |
| j | 367647 | |
| u | 351075 | |
| b | 207407 | 7.8% |
| d | 143668 | 5.4% |
| l | 116553 | 4.4% |
| n | 63739 | 2.4% |
| i | 63739 | 2.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 575054 | |
| Y | 52814 | 8.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3277743 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 575054 | |
| a | 537014 | |
| g | 367647 | |
| o | 367647 | |
| j | 367647 | |
| u | 351075 | |
| b | 207407 | 6.3% |
| d | 143668 | 4.4% |
| l | 116553 | 3.6% |
| n | 63739 | 1.9% |
| Other values (3) | 180292 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3277743 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 575054 | |
| a | 537014 | |
| g | 367647 | |
| o | 367647 | |
| j | 367647 | |
| u | 351075 | |
| b | 207407 | 6.3% |
| d | 143668 | 4.4% |
| l | 116553 | 3.6% |
| n | 63739 | 1.9% |
| Other values (3) | 180292 | 5.5% |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| Ogoja General Hospital | |
|---|---|
| Ogoja Catholic Maternity Hospital | |
| Sacred Heart Catholic Hospital | |
| Obanliku General Hospital | |
| Yala Lutheran Hospital | |
| Other values (6) |
Length
| Max length | 35 |
|---|---|
| Median length | 25 |
| Mean length | 26.72374607 |
| Min length | 12 |
Characters and Unicode
| Total characters | 16778985 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Obudu Clinic |
|---|---|
| 2nd row | Obudu Clinic |
| 3rd row | Obudu Clinic |
| 4th row | Obudu Clinic |
| 5th row | Obudu Clinic |
Common Values
| Value | Count | Frequency (%) |
| Ogoja General Hospital | 193461 | |
| Ogoja Catholic Maternity Hospital | 158799 | |
| Sacred Heart Catholic Hospital | 118501 | |
| Obanliku General Hospital | 63739 | 10.2% |
| Yala Lutheran Hospital | 30441 | 4.8% |
| Obudu Clinic | 17916 | 2.9% |
| Ogoja Santa Maria Clinic | 15387 | 2.5% |
| Oba Comprehensive Health Centre | 9632 | 1.5% |
| Okpoma General Hospital | 9256 | 1.5% |
| Obudu Urban1 Primary Health Centre | 7251 | 1.2% |
Length
| Value | Count | Frequency (%) |
| hospital | 574197 | |
| ogoja | 367647 | |
| catholic | 277300 | |
| general | 266456 | |
| maternity | 158799 | 7.3% |
| sacred | 118501 | 5.4% |
| heart | 118501 | 5.4% |
| obanliku | 63739 | 2.9% |
| clinic | 33303 | 1.5% |
| yala | 30441 | 1.4% |
| Other values (12) | 177110 | 8.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2155254 | |
| 1558126 | 9.3% | |
| t | 1374160 | 8.2% |
| l | 1265804 | 7.5% |
| o | 1241517 | 7.4% |
| i | 1179881 | 7.0% |
| e | 1063094 | 6.3% |
| r | 763323 | 4.5% |
| H | 713066 | 4.2% |
| n | 612346 | 3.6% |
| Other values (24) | 4852414 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 13027614 | |
| Uppercase Letter | 2185994 | 13.0% |
| Space Separator | 1558126 | 9.3% |
| Decimal Number | 7251 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2155254 | |
| t | 1374160 | |
| l | 1265804 | |
| o | 1241517 | |
| i | 1179881 | |
| e | 1063094 | |
| r | 763323 | 5.9% |
| n | 612346 | 4.7% |
| p | 596570 | 4.6% |
| s | 587314 | 4.5% |
| Other values (11) | 2188351 |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 713066 | |
| O | 475441 | |
| C | 344088 | |
| G | 266456 | 12.2% |
| M | 174186 | 8.0% |
| S | 133888 | 6.1% |
| Y | 30441 | 1.4% |
| L | 30441 | 1.4% |
| U | 7251 | 0.3% |
| P | 7251 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 1558126 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 7251 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15213608 | |
| Common | 1565377 | 9.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 2155254 | |
| t | 1374160 | 9.0% |
| l | 1265804 | 8.3% |
| o | 1241517 | 8.2% |
| i | 1179881 | 7.8% |
| e | 1063094 | 7.0% |
| r | 763323 | 5.0% |
| H | 713066 | 4.7% |
| n | 612346 | 4.0% |
| p | 596570 | 3.9% |
| Other values (22) | 4248593 |
Common
| Value | Count | Frequency (%) |
| 1558126 | ||
| 1 | 7251 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16778985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 2155254 | |
| 1558126 | 9.3% | |
| t | 1374160 | 8.2% |
| l | 1265804 | 7.5% |
| o | 1241517 | 7.4% |
| i | 1179881 | 7.0% |
| e | 1063094 | 6.3% |
| r | 763323 | 4.5% |
| H | 713066 | 4.2% |
| n | 612346 | 3.6% |
| Other values (24) | 4852414 |
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| ART First Line Adult | |
|---|---|
| Cotrimoxazole (CTX) Prophylaxis | |
| ART First Line Children | 21258 |
| Isoniazid Preventive Therapy (IPT) | 19569 |
| ART Second Line Adult | 18451 |
| Other values (8) | 863 |
Length
| Max length | 46 |
|---|---|
| Median length | 20 |
| Mean length | 22.29019635 |
| Min length | 4 |
Characters and Unicode
| Total characters | 13995301 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ART First Line Adult |
|---|---|
| 2nd row | ART First Line Adult |
| 3rd row | ART First Line Adult |
| 4th row | Cotrimoxazole (CTX) Prophylaxis |
| 5th row | ART First Line Adult |
Common Values
| Value | Count | Frequency (%) |
| ART First Line Adult | 469457 | |
| Cotrimoxazole (CTX) Prophylaxis | 98270 | 15.7% |
| ART First Line Children | 21258 | 3.4% |
| Isoniazid Preventive Therapy (IPT) | 19569 | 3.1% |
| ART Second Line Adult | 18451 | 2.9% |
| ART Second Line Children | 612 | 0.1% |
| OI Treatment | 209 | < 0.1% |
| Other Medicines | 22 | < 0.1% |
| TB Treatment Adult | 9 | < 0.1% |
| Other anti-infectives (including STI Medicine) | 5 | < 0.1% |
| Other values (3) | 6 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| art | 509778 | |
| line | 509778 | |
| first | 490715 | |
| adult | 487917 | |
| prophylaxis | 98273 | 4.1% |
| cotrimoxazole | 98270 | 4.1% |
| ctx | 98270 | 4.1% |
| children | 21871 | 0.9% |
| therapy | 19569 | 0.8% |
| preventive | 19569 | 0.8% |
| Other values (16) | 58719 | 2.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1784861 | 12.8% | |
| i | 1277693 | 9.1% |
| t | 1096949 | 7.8% |
| A | 997695 | 7.1% |
| r | 748518 | 5.3% |
| e | 727790 | 5.2% |
| l | 706336 | 5.0% |
| T | 647420 | 4.6% |
| s | 608590 | 4.3% |
| n | 590116 | 4.2% |
| Other values (29) | 4809333 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8306549 | |
| Uppercase Letter | 3668192 | |
| Space Separator | 1784861 | 12.8% |
| Open Punctuation | 117847 | 0.8% |
| Close Punctuation | 117847 | 0.8% |
| Dash Punctuation | 5 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 1277693 | |
| t | 1096949 | |
| r | 748518 | |
| e | 727790 | |
| l | 706336 | |
| s | 608590 | |
| n | 590116 | |
| d | 548452 | |
| u | 487925 | 5.9% |
| o | 431721 | 5.2% |
| Other values (11) | 1082459 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 997695 | |
| T | 647420 | |
| R | 509778 | |
| L | 509778 | |
| F | 490715 | |
| C | 218411 | 6.0% |
| P | 137424 | 3.7% |
| X | 98270 | 2.7% |
| I | 39352 | 1.1% |
| S | 19068 | 0.5% |
| Other values (4) | 281 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1784861 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 117847 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 117847 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11974741 | |
| Common | 2020560 | 14.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 1277693 | 10.7% |
| t | 1096949 | 9.2% |
| A | 997695 | 8.3% |
| r | 748518 | 6.3% |
| e | 727790 | 6.1% |
| l | 706336 | 5.9% |
| T | 647420 | 5.4% |
| s | 608590 | 5.1% |
| n | 590116 | 4.9% |
| d | 548452 | 4.6% |
| Other values (25) | 4025182 |
Common
| Value | Count | Frequency (%) |
| 1784861 | ||
| ( | 117847 | 5.8% |
| ) | 117847 | 5.8% |
| - | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13995301 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1784861 | 12.8% | |
| i | 1277693 | 9.1% |
| t | 1096949 | 7.8% |
| A | 997695 | 7.1% |
| r | 748518 | 5.3% |
| e | 727790 | 5.2% |
| l | 706336 | 5.0% |
| T | 647420 | 4.6% |
| s | 608590 | 4.3% |
| n | 590116 | 4.2% |
| Other values (29) | 4809333 |
| Distinct | 88 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| TDF(300mg)+3TC(300mg)+DTG(50mg) | |
|---|---|
| TDF(300mg)+3TC(300mg)+EFV(600mg) | |
| AZT(300mg)+3TC(150mg)+NVP(200mg) | |
| Cotrimoxazole 960mg | |
| Isoniazid 300mg | 19095 |
| Other values (83) |
Length
| Max length | 62 |
|---|---|
| Median length | 31 |
| Mean length | 29.32948008 |
| Min length | 12 |
Characters and Unicode
| Total characters | 18415042 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | TDF(300mg)+3TC(300mg)+DTG(50mg) |
|---|---|
| 2nd row | TDF(300mg)+3TC(300mg)+EFV(600mg) |
| 3rd row | TDF(300mg)+3TC(300mg)+DTG(50mg) |
| 4th row | Cotrimoxazole 960mg |
| 5th row | TDF(300mg)+3TC(300mg)+EFV(600mg) |
Common Values
| Value | Count | Frequency (%) |
| TDF(300mg)+3TC(300mg)+DTG(50mg) | 206641 | |
| TDF(300mg)+3TC(300mg)+EFV(600mg) | 150496 | |
| AZT(300mg)+3TC(150mg)+NVP(200mg) | 101110 | |
| Cotrimoxazole 960mg | 93214 | |
| Isoniazid 300mg | 19095 | 3.0% |
| AZT(10mg/ml)+3TC(10mg/ml)+NVP(10mg/ml) | 11386 | 1.8% |
| TDF(300mg)+3TC(150mg)+LPV/r(200/50mg) | 6349 | 1.0% |
| Cotrimoxazole 480mg | 4351 | 0.7% |
| TDF(300mg)+3TC(150mg)+ATV/r(300/100mg) | 4296 | 0.7% |
| TDF(300mg)+3TC(30mg)+DTG(50mg) | 3367 | 0.5% |
| Other values (78) | 27563 | 4.4% |
Length
| Value | Count | Frequency (%) |
| tdf(300mg)+3tc(300mg)+dtg(50mg | 206641 | |
| tdf(300mg)+3tc(300mg)+efv(600mg | 150496 | |
| azt(300mg)+3tc(150mg)+nvp(200mg | 101110 | |
| cotrimoxazole | 98366 | |
| 960mg | 93214 | |
| isoniazid | 19479 | 2.6% |
| 300mg | 19095 | 2.6% |
| azt(10mg/ml)+3tc(10mg/ml)+nvp(10mg/ml | 11386 | 1.5% |
| tdf(300mg)+3tc(150mg)+lpv/r(200/50mg | 6349 | 0.9% |
| 480mg | 4351 | 0.6% |
| Other values (91) | 35457 | 4.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2836166 | |
| m | 1775684 | |
| g | 1639258 | 8.9% |
| ( | 1520232 | 8.3% |
| ) | 1520232 | 8.3% |
| 3 | 1401695 | 7.6% |
| T | 1235348 | 6.7% |
| + | 1010449 | 5.5% |
| C | 613857 | 3.3% |
| D | 592983 | 3.2% |
| Other values (46) | 4269138 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5235615 | |
| Lowercase Letter | 4715096 | |
| Uppercase Letter | 4196819 | |
| Open Punctuation | 1520232 | 8.3% |
| Close Punctuation | 1520232 | 8.3% |
| Math Symbol | 1010449 | 5.5% |
| Space Separator | 118076 | 0.6% |
| Other Punctuation | 98523 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| m | 1775684 | |
| g | 1639258 | |
| o | 315008 | 6.7% |
| i | 137427 | 2.9% |
| l | 136815 | 2.9% |
| r | 119388 | 2.5% |
| a | 118103 | 2.5% |
| z | 118061 | 2.5% |
| e | 98609 | 2.1% |
| t | 98436 | 2.1% |
| Other values (12) | 158307 | 3.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 1235348 | |
| C | 613857 | |
| D | 592983 | |
| F | 537658 | |
| V | 296700 | 7.1% |
| G | 212685 | 5.1% |
| E | 155724 | 3.7% |
| A | 137570 | 3.3% |
| P | 132729 | 3.2% |
| Z | 123629 | 2.9% |
| Other values (8) | 157936 | 3.8% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2836166 | |
| 3 | 1401695 | |
| 5 | 347525 | 6.6% |
| 6 | 253126 | 4.8% |
| 1 | 167747 | 3.2% |
| 2 | 123543 | 2.4% |
| 9 | 93214 | 1.8% |
| 4 | 7551 | 0.1% |
| 8 | 4954 | 0.1% |
| 7 | 94 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 98522 | |
| , | 1 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1520232 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1520232 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 1010449 |
Space Separator
| Value | Count | Frequency (%) |
| 118076 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 9503127 | |
| Latin | 8911915 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| m | 1775684 | |
| g | 1639258 | |
| T | 1235348 | |
| C | 613857 | 6.9% |
| D | 592983 | 6.7% |
| F | 537658 | 6.0% |
| o | 315008 | 3.5% |
| V | 296700 | 3.3% |
| G | 212685 | 2.4% |
| E | 155724 | 1.7% |
| Other values (30) | 1537010 |
Common
| Value | Count | Frequency (%) |
| 0 | 2836166 | |
| ( | 1520232 | |
| ) | 1520232 | |
| 3 | 1401695 | |
| + | 1010449 | 10.6% |
| 5 | 347525 | 3.7% |
| 6 | 253126 | 2.7% |
| 1 | 167747 | 1.8% |
| 2 | 123543 | 1.3% |
| 118076 | 1.2% | |
| Other values (6) | 204336 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18415042 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2836166 | |
| m | 1775684 | |
| g | 1639258 | 8.9% |
| ( | 1520232 | 8.3% |
| ) | 1520232 | 8.3% |
| 3 | 1401695 | 7.6% |
| T | 1235348 | 6.7% |
| + | 1010449 | 5.5% |
| C | 613857 | 3.3% |
| D | 592983 | 3.2% |
| Other values (46) | 4269138 |
| Distinct | 627868 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1776095.166 |
| Minimum | 43649 |
|---|---|
| Maximum | 4082401 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 43649 |
|---|---|
| 5-th percentile | 258862.15 |
| Q1 | 708182.75 |
| median | 1362669 |
| Q3 | 3126253.25 |
| 95-th percentile | 3824185.65 |
| Maximum | 4082401 |
| Range | 4038752 |
| Interquartile range (IQR) | 2418070.5 |
Descriptive statistics
| Standard deviation | 1255255.564 |
|---|---|
| Coefficient of variation (CV) | 0.7067501717 |
| Kurtosis | -1.314320371 |
| Mean | 1776095.166 |
| Median Absolute Deviation (MAD) | 817529 |
| Skewness | 0.4738560264 |
| Sum | 1.11515332 × 1012 |
| Variance | 1.57566653 × 1012 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1054723 | 1 | < 0.1% |
| 2840650 | 1 | < 0.1% |
| 238369 | 1 | < 0.1% |
| 244514 | 1 | < 0.1% |
| 1291043 | 1 | < 0.1% |
| 232228 | 1 | < 0.1% |
| 2800320 | 1 | < 0.1% |
| 234279 | 1 | < 0.1% |
| 258859 | 1 | < 0.1% |
| 250671 | 1 | < 0.1% |
| Other values (627858) | 627858 |
| Value | Count | Frequency (%) |
| 43649 | 1 | |
| 43651 | 1 | |
| 43655 | 1 | |
| 43658 | 1 | |
| 43663 | 1 | |
| 43665 | 1 | |
| 43667 | 1 | |
| 43671 | 1 | |
| 43673 | 1 | |
| 43676 | 1 |
| Value | Count | Frequency (%) |
| 4082401 | 1 | |
| 4082400 | 1 | |
| 4082399 | 1 | |
| 4082398 | 1 | |
| 4082397 | 1 | |
| 4082392 | 1 | |
| 4082391 | 1 | |
| 4082390 | 1 | |
| 4082386 | 1 | |
| 4082385 | 1 |
| Distinct | 18825 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52581.71467 |
| Minimum | 19095 |
|---|---|
| Maximum | 160831 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 19095 |
|---|---|
| 5-th percentile | 20738 |
| Q1 | 24167 |
| median | 29628 |
| Q3 | 35078 |
| 95-th percentile | 148392 |
| Maximum | 160831 |
| Range | 141736 |
| Interquartile range (IQR) | 10911 |
Descriptive statistics
| Standard deviation | 47159.52209 |
|---|---|
| Coefficient of variation (CV) | 0.8968806434 |
| Kurtosis | -0.0603474067 |
| Mean | 52581.71467 |
| Median Absolute Deviation (MAD) | 5458 |
| Skewness | 1.341205344 |
| Sum | 3.301437603 × 1010 |
| Variance | 2224020523 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 148161 | 233 | < 0.1% |
| 113055 | 231 | < 0.1% |
| 89158 | 228 | < 0.1% |
| 112854 | 224 | < 0.1% |
| 116818 | 216 | < 0.1% |
| 147777 | 212 | < 0.1% |
| 112907 | 210 | < 0.1% |
| 89206 | 202 | < 0.1% |
| 116999 | 194 | < 0.1% |
| 112807 | 193 | < 0.1% |
| Other values (18815) | 625725 |
| Value | Count | Frequency (%) |
| 19095 | 4 | < 0.1% |
| 19098 | 1 | < 0.1% |
| 19101 | 44 | |
| 19104 | 78 | |
| 19107 | 8 | < 0.1% |
| 19110 | 85 | |
| 19111 | 79 | |
| 19117 | 4 | < 0.1% |
| 19120 | 50 | |
| 19123 | 107 |
| Value | Count | Frequency (%) |
| 160831 | 4 | < 0.1% |
| 160808 | 4 | < 0.1% |
| 160807 | 4 | < 0.1% |
| 160806 | 4 | < 0.1% |
| 160805 | 4 | < 0.1% |
| 160804 | 4 | < 0.1% |
| 160802 | 10 | < 0.1% |
| 160801 | 106 | |
| 160800 | 5 | < 0.1% |
| 160799 | 5 | < 0.1% |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1888.15524 |
| Minimum | 1686 |
|---|---|
| Maximum | 2935 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 1686 |
|---|---|
| 5-th percentile | 1696 |
| Q1 | 1752 |
| median | 1753 |
| Q3 | 1753 |
| 95-th percentile | 2929 |
| Maximum | 2935 |
| Range | 1249 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 390.4319905 |
|---|---|
| Coefficient of variation (CV) | 0.2067796028 |
| Kurtosis | 3.22749184 |
| Mean | 1888.15524 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.272684395 |
| Sum | 1185512254 |
| Variance | 152437.1392 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1753 | 193461 | |
| 1752 | 158799 | |
| 1696 | 118501 | |
| 2929 | 63739 | 10.2% |
| 1831 | 30441 | 4.8% |
| 1686 | 17916 | 2.9% |
| 1755 | 15387 | 2.5% |
| 2935 | 9632 | 1.5% |
| 1817 | 9256 | 1.5% |
| 1687 | 7251 | 1.2% |
| Value | Count | Frequency (%) |
| 1686 | 17916 | 2.9% |
| 1687 | 7251 | 1.2% |
| 1696 | 118501 | |
| 1752 | 158799 | |
| 1753 | 193461 | |
| 1755 | 15387 | 2.5% |
| 1817 | 9256 | 1.5% |
| 1831 | 30441 | 4.8% |
| 2929 | 63739 | 10.2% |
| 2933 | 3485 | 0.6% |
| Value | Count | Frequency (%) |
| 2935 | 9632 | 1.5% |
| 2933 | 3485 | 0.6% |
| 2929 | 63739 | 10.2% |
| 1831 | 30441 | 4.8% |
| 1817 | 9256 | 1.5% |
| 1755 | 15387 | 2.5% |
| 1753 | 193461 | |
| 1752 | 158799 | |
| 1696 | 118501 | |
| 1687 | 7251 | 1.2% |
| Distinct | 145 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.84280295 |
| Minimum | -30 |
|---|---|
| Maximum | 90212 |
| Zeros | 140 |
| Zeros (%) | < 0.1% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | -30 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 60 |
| median | 60 |
| Q3 | 90 |
| 95-th percentile | 180 |
| Maximum | 90212 |
| Range | 90242 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 124.3629103 |
|---|---|
| Coefficient of variation (CV) | 1.597616036 |
| Kurtosis | 439469.154 |
| Mean | 77.84280295 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 606.5115674 |
| Sum | 48875005 |
| Variance | 15466.13346 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60 | 271500 | |
| 30 | 123588 | |
| 90 | 102713 | 16.4% |
| 180 | 76678 | 12.2% |
| 120 | 26150 | 4.2% |
| 15 | 7481 | 1.2% |
| 14 | 3859 | 0.6% |
| 56 | 3111 | 0.5% |
| 168 | 2643 | 0.4% |
| 84 | 1949 | 0.3% |
| Other values (135) | 8196 | 1.3% |
| Value | Count | Frequency (%) |
| -30 | 1 | < 0.1% |
| 0 | 140 | |
| 1 | 4 | < 0.1% |
| 2 | 35 | < 0.1% |
| 3 | 18 | < 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 26 | < 0.1% |
| 7 | 11 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 90212 | 1 | < 0.1% |
| 1800 | 7 | |
| 1680 | 3 | |
| 1220 | 1 | < 0.1% |
| 1180 | 1 | < 0.1% |
| 1120 | 1 | < 0.1% |
| 1112 | 1 | < 0.1% |
| 960 | 7 | |
| 900 | 2 | < 0.1% |
| 601 | 3 |
| Distinct | 42 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.767379212 |
| Minimum | 0 |
|---|---|
| Maximum | 2401 |
| Zeros | 225607 |
| Zeros (%) | 35.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 2401 |
| Range | 2401 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 9.062837272 |
|---|---|
| Coefficient of variation (CV) | 11.81011569 |
| Kurtosis | 25144.8799 |
| Mean | 0.767379212 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 148.0439747 |
| Sum | 481812.8511 |
| Variance | 82.13501941 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 381250 | |
| 0 | 225607 | |
| 3 | 13055 | 2.1% |
| 2 | 7798 | 1.2% |
| 10 | 39 | < 0.1% |
| 11 | 25 | < 0.1% |
| 1201 | 17 | < 0.1% |
| 601 | 9 | < 0.1% |
| 1.03 | 7 | < 0.1% |
| 31 | 5 | < 0.1% |
| Other values (32) | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 225607 | |
| 0.03 | 3 | < 0.1% |
| 0.06 | 1 | < 0.1% |
| 1 | 381250 | |
| 1.0112 | 1 | < 0.1% |
| 1.015 | 1 | < 0.1% |
| 1.018 | 1 | < 0.1% |
| 1.03 | 7 | < 0.1% |
| 1.05 | 1 | < 0.1% |
| 1.056 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2401 | 1 | < 0.1% |
| 1960 | 1 | < 0.1% |
| 1801 | 1 | < 0.1% |
| 1511 | 1 | < 0.1% |
| 1201 | 17 | |
| 960 | 4 | < 0.1% |
| 901 | 4 | < 0.1% |
| 603 | 2 | < 0.1% |
| 601 | 9 | |
| 600 | 1 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| 0 | |
|---|---|
| 960 | 5 |
| 1 | 5 |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.000015927 |
| Min length | 1 |
Characters and Unicode
| Total characters | 627878 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 627858 | |
| 960 | 5 | < 0.1% |
| 1 | 5 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 627858 | |
| 960 | 5 | < 0.1% |
| 1 | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 627863 | |
| 1 | 5 | < 0.1% |
| 9 | 5 | < 0.1% |
| 6 | 5 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 627878 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 627863 | |
| 1 | 5 | < 0.1% |
| 9 | 5 | < 0.1% |
| 6 | 5 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 627878 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 627863 | |
| 1 | 5 | < 0.1% |
| 9 | 5 | < 0.1% |
| 6 | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 627878 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 627863 | |
| 1 | 5 | < 0.1% |
| 9 | 5 | < 0.1% |
| 6 | 5 | < 0.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.738782037 |
| Minimum | 0 |
|---|---|
| Maximum | 960 |
| Zeros | 199008 |
| Zeros (%) | 31.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 960 |
| Range | 960 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.788758845 |
|---|---|
| Coefficient of variation (CV) | 3.774805971 |
| Kurtosis | 111518.0424 |
| Mean | 0.738782037 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 324.8214677 |
| Sum | 463857.6 |
| Variance | 7.777175895 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 412371 | |
| 0 | 199008 | |
| 3 | 13048 | 2.1% |
| 2 | 3415 | 0.5% |
| 960 | 5 | < 0.1% |
| 10 | 4 | < 0.1% |
| 1.5 | 3 | < 0.1% |
| 2.5 | 3 | < 0.1% |
| 100 | 2 | < 0.1% |
| 20 | 2 | < 0.1% |
| Other values (7) | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 199008 | |
| 0.1 | 1 | < 0.1% |
| 1 | 412371 | |
| 1.5 | 3 | < 0.1% |
| 2 | 3415 | 0.5% |
| 2.5 | 3 | < 0.1% |
| 3 | 13048 | 2.1% |
| 3.5 | 1 | < 0.1% |
| 10 | 4 | < 0.1% |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 960 | 5 | |
| 180 | 1 | < 0.1% |
| 112 | 1 | < 0.1% |
| 100 | 2 | < 0.1% |
| 84 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 4 | |
| 3.5 | 1 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10322 |
| Missing (%) | 1.6% |
| Memory size | 1.2 MiB |
| False | |
|---|---|
| True | 1839 |
| (Missing) | 10322 |
| Value | Count | Frequency (%) |
| False | 615707 | |
| True | 1839 | 0.3% |
| (Missing) | 10322 | 1.6% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 30.0% |
| Missing | 627858 |
| Missing (%) | > 99.9% |
| Memory size | 4.8 MiB |
| 10,1 | |
|---|---|
| 4,6#1,1 | |
| 8#1 |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.6 |
| Min length | 3 |
Characters and Unicode
| Total characters | 46 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10,1 |
|---|---|
| 2nd row | 10,1 |
| 3rd row | 4,6#1,1 |
| 4th row | 10,1 |
| 5th row | 10,1 |
Common Values
| Value | Count | Frequency (%) |
| 10,1 | 4 | < 0.1% |
| 4,6#1,1 | 3 | < 0.1% |
| 8#1 | 3 | < 0.1% |
| (Missing) | 627858 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 10,1 | 4 | |
| 8#1 | 3 | |
| 4,6#1,1 | 3 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 17 | |
| , | 10 | |
| # | 6 | 13.0% |
| 0 | 4 | 8.7% |
| 4 | 3 | 6.5% |
| 6 | 3 | 6.5% |
| 8 | 3 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 30 | |
| Other Punctuation | 16 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 17 | |
| 0 | 4 | 13.3% |
| 4 | 3 | 10.0% |
| 6 | 3 | 10.0% |
| 8 | 3 | 10.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 10 | |
| # | 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 46 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 17 | |
| , | 10 | |
| # | 6 | 13.0% |
| 0 | 4 | 8.7% |
| 4 | 3 | 6.5% |
| 6 | 3 | 6.5% |
| 8 | 3 | 6.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 17 | |
| , | 10 | |
| # | 6 | 13.0% |
| 0 | 4 | 8.7% |
| 4 | 3 | 6.5% |
| 6 | 3 | 6.5% |
| 8 | 3 | 6.5% |
PRESCRIP_ERROR
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| 0 | |
|---|---|
| 1 | 10143 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 627868 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 617725 | |
| 1 | 10143 | 1.6% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 617725 | |
| 1 | 10143 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 617725 | |
| 1 | 10143 | 1.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 627868 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 617725 | |
| 1 | 10143 | 1.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 627868 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 617725 | |
| 1 | 10143 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 627868 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 617725 | |
| 1 | 10143 | 1.6% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 627868 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 346979 | |
| 0 | 280889 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 346979 | |
| 0 | 280889 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 346979 | |
| 0 | 280889 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 627868 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 346979 | |
| 0 | 280889 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 627868 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 346979 | |
| 0 | 280889 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 627868 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 346979 | |
| 0 | 280889 |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 460552 |
| Missing (%) | 73.4% |
| Memory size | 4.8 MiB |
| MMD | |
|---|---|
| Same Facility Refill | |
| Individual delivery/home-based | |
| MMS | |
| CPARP | 925 |
| Other values (6) | 631 |
Length
| Max length | 51 |
|---|---|
| Median length | 3 |
| Mean length | 11.95987831 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2001079 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MMD |
|---|---|
| 2nd row | MMD |
| 3rd row | MMD |
| 4th row | MMS |
| 5th row | Same Facility Refill |
Common Values
| Value | Count | Frequency (%) |
| MMD | 76108 | 12.1% |
| Same Facility Refill | 53701 | 8.6% |
| Individual delivery/home-based | 21053 | 3.4% |
| MMS | 14898 | 2.4% |
| CPARP | 925 | 0.1% |
| Different Facility Refill (Private hospital/clinic) | 269 | < 0.1% |
| CARC | 199 | < 0.1% |
| Group delivery/CARC | 99 | < 0.1% |
| Mobile van/other vehicle | 40 | < 0.1% |
| Fixed or ad hoc pick up points | 14 | < 0.1% |
| (Missing) | 460552 |
Length
| Value | Count | Frequency (%) |
| mmd | 76108 | |
| facility | 53970 | |
| refill | 53970 | |
| same | 53701 | |
| individual | 21053 | 7.1% |
| delivery/home-based | 21053 | 7.1% |
| mms | 14898 | 5.0% |
| cparp | 925 | 0.3% |
| hospital/clinic | 269 | 0.1% |
| private | 269 | 0.1% |
| Other values (15) | 894 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 226635 | 11.3% |
| l | 204733 | 10.2% |
| e | 193072 | 9.6% |
| M | 182052 | 9.1% |
| a | 150369 | 7.5% |
| 129794 | 6.5% | |
| d | 84339 | 4.2% |
| D | 76377 | 3.8% |
| y | 75122 | 3.8% |
| m | 74754 | 3.7% |
| Other values (27) | 603832 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1366003 | |
| Uppercase Letter | 462230 | 23.1% |
| Space Separator | 129794 | 6.5% |
| Other Punctuation | 21461 | 1.1% |
| Dash Punctuation | 21053 | 1.1% |
| Open Punctuation | 269 | < 0.1% |
| Close Punctuation | 269 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 226635 | |
| l | 204733 | |
| e | 193072 | |
| a | 150369 | |
| d | 84339 | 6.2% |
| y | 75122 | 5.5% |
| m | 74754 | 5.5% |
| t | 54841 | 4.0% |
| c | 54576 | 4.0% |
| f | 54508 | 4.0% |
| Other values (11) | 193054 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 182052 | |
| D | 76377 | |
| S | 68599 | 14.8% |
| R | 55193 | 11.9% |
| F | 53984 | 11.7% |
| I | 21053 | 4.6% |
| P | 2119 | 0.5% |
| C | 1521 | 0.3% |
| A | 1223 | 0.3% |
| G | 99 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 129794 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 21461 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 21053 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 269 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 269 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1828233 | |
| Common | 172846 | 8.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 226635 | |
| l | 204733 | |
| e | 193072 | 10.6% |
| M | 182052 | 10.0% |
| a | 150369 | 8.2% |
| d | 84339 | 4.6% |
| D | 76377 | 4.2% |
| y | 75122 | 4.1% |
| m | 74754 | 4.1% |
| S | 68599 | 3.8% |
| Other values (22) | 492181 |
Common
| Value | Count | Frequency (%) |
| 129794 | ||
| / | 21461 | 12.4% |
| - | 21053 | 12.2% |
| ( | 269 | 0.2% |
| ) | 269 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2001079 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 226635 | 11.3% |
| l | 204733 | 10.2% |
| e | 193072 | 9.6% |
| M | 182052 | 9.1% |
| a | 150369 | 7.5% |
| 129794 | 6.5% | |
| d | 84339 | 4.2% |
| D | 76377 | 3.8% |
| y | 75122 | 3.8% |
| m | 74754 | 3.7% |
| Other values (27) | 603832 |
| Distinct | 75 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.138822348 |
| Minimum | 0 |
|---|---|
| Maximum | 856 |
| Zeros | 625049 |
| Zeros (%) | 99.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 856 |
| Range | 856 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.469496776 |
|---|---|
| Coefficient of variation (CV) | 24.99235048 |
| Kurtosis | 31028.80829 |
| Mean | 0.138822348 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 138.7964098 |
| Sum | 87162.11 |
| Variance | 12.03740788 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 625049 | |
| 30 | 254 | < 0.1% |
| 20 | 244 | < 0.1% |
| 25 | 216 | < 0.1% |
| 68 | 137 | < 0.1% |
| 17 | 109 | < 0.1% |
| 56 | 104 | < 0.1% |
| 10 | 101 | < 0.1% |
| 21 | 99 | < 0.1% |
| 15 | 99 | < 0.1% |
| Other values (65) | 1456 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 625049 | |
| 0.25 | 3 | < 0.1% |
| 1.1 | 3 | < 0.1% |
| 1.3 | 4 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 9 | < 0.1% |
| 7 | 12 | < 0.1% |
| 8 | 14 | < 0.1% |
| 8.5 | 3 | < 0.1% |
| 9 | 49 | < 0.1% |
| Value | Count | Frequency (%) |
| 856 | 4 | < 0.1% |
| 687 | 3 | < 0.1% |
| 78 | 39 | < 0.1% |
| 72 | 3 | < 0.1% |
| 71 | 6 | < 0.1% |
| 69 | 11 | < 0.1% |
| 68 | 137 | |
| 65 | 45 | < 0.1% |
| 64 | 53 | < 0.1% |
| 63 | 3 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| State | L.G.A | Facility Name | Regimen Line | Regimen | PHARMACY_ID | PATIENT_ID | FACILITY_ID | DATE_VISIT | DURATION | MORNING | AFTERNOON | EVENING | ADR_SCREENED | ADR_IDS | PRESCRIP_ERROR | ADHERENCE | NEXT_APPOINTMENT | DMOC_TYPE | BODY_WEIGHT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Cross River | Obudu | Obudu Clinic | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 43649 | 19757 | 1686 | 2019-06-05 00:00:00 | 60 | 1.0 | 0 | 0.0 | No | NaN | 0 | 1 | 2019-08-05 00:00:00 | NaN | 0.0 |
| 1 | Cross River | Obudu | Obudu Clinic | ART First Line Adult | TDF(300mg)+3TC(300mg)+EFV(600mg) | 43651 | 19228 | 1686 | 2017-07-18 00:00:00 | 60 | 1.0 | 0 | 1.0 | No | NaN | 0 | 1 | 2017-09-16 00:00:00 | NaN | 0.0 |
| 2 | Cross River | Obudu | Obudu Clinic | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 43655 | 19182 | 1686 | 2020-04-24 00:00:00 | 180 | 0.0 | 0 | 1.0 | No | NaN | 0 | 0 | 2020-10-24 00:00:00 | MMD | 0.0 |
| 3 | Cross River | Obudu | Obudu Clinic | Cotrimoxazole (CTX) Prophylaxis | Cotrimoxazole 960mg | 43658 | 19123 | 1686 | 2016-10-19 00:00:00 | 60 | 1.0 | 0 | 0.0 | No | NaN | 0 | 1 | 2016-12-19 00:00:00 | NaN | 0.0 |
| 4 | Cross River | Obudu | Obudu Clinic | ART First Line Adult | TDF(300mg)+3TC(300mg)+EFV(600mg) | 43663 | 19764 | 1686 | 2017-05-23 00:00:00 | 30 | 1.0 | 0 | 1.0 | No | NaN | 0 | 1 | 2017-06-21 00:00:00 | NaN | 0.0 |
| 5 | Cross River | Obudu | Obudu Clinic | ART First Line Children | AZT/3TC/NVP(60/30/50mg) | 43665 | 19487 | 1686 | 2017-06-23 00:00:00 | 120 | 1.0 | 0 | 1.0 | No | NaN | 0 | 1 | 2017-08-23 00:00:00 | NaN | 0.0 |
| 6 | Cross River | Obudu | Obudu Clinic | ART First Line Adult | TDF(300mg)+3TC(300mg)+EFV(600mg) | 43667 | 19832 | 1686 | 2019-02-21 00:00:00 | 60 | 1.0 | 0 | 1.0 | No | NaN | 0 | 1 | 2019-04-21 00:00:00 | NaN | 0.0 |
| 7 | Cross River | Obudu | Obudu Clinic | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 43671 | 19759 | 1686 | 2019-06-15 00:00:00 | 60 | 0.0 | 0 | 1.0 | No | NaN | 0 | 1 | 2019-08-15 00:00:00 | NaN | 0.0 |
| 8 | Cross River | Obudu | Obudu Clinic | ART First Line Adult | AZT(300mg)+3TC(150mg)+NVP(200mg) | 43673 | 19475 | 1686 | 2016-11-21 00:00:00 | 60 | 1.0 | 0 | 1.0 | No | NaN | 0 | 1 | 2017-01-19 00:00:00 | NaN | 0.0 |
| 9 | Cross River | Obudu | Obudu Clinic | Cotrimoxazole (CTX) Prophylaxis | Cotrimoxazole 960mg | 43676 | 19934 | 1686 | 2020-02-11 00:00:00 | 90 | 1.0 | 0 | 0.0 | No | NaN | 0 | 0 | 2020-05-11 00:00:00 | MMD | 0.0 |
Last rows
| State | L.G.A | Facility Name | Regimen Line | Regimen | PHARMACY_ID | PATIENT_ID | FACILITY_ID | DATE_VISIT | DURATION | MORNING | AFTERNOON | EVENING | ADR_SCREENED | ADR_IDS | PRESCRIP_ERROR | ADHERENCE | NEXT_APPOINTMENT | DMOC_TYPE | BODY_WEIGHT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 627858 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082385 | 24597 | 1752 | 2021-05-26 00:00:00 | 180 | 1.0 | 0 | 0.0 | No | NaN | 0 | 0 | 2021-11-29 00:00:00 | Same Facility Refill | 0.0 |
| 627859 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082386 | 113174 | 1752 | 2021-05-25 00:00:00 | 180 | 0.0 | 0 | 1.0 | No | NaN | 0 | 0 | 2021-11-23 00:00:00 | Same Facility Refill | 0.0 |
| 627860 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082390 | 154849 | 1752 | 2021-05-25 00:00:00 | 90 | 0.0 | 0 | 1.0 | No | NaN | 0 | 0 | 2021-08-27 00:00:00 | Same Facility Refill | 0.0 |
| 627861 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082391 | 23910 | 1752 | 2021-05-25 00:00:00 | 180 | 0.0 | 0 | 1.0 | No | NaN | 0 | 0 | 2021-11-16 00:00:00 | Same Facility Refill | 0.0 |
| 627862 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082392 | 26495 | 1752 | 2021-05-26 00:00:00 | 180 | 0.0 | 0 | 1.0 | No | NaN | 0 | 0 | 2021-11-29 00:00:00 | Same Facility Refill | 0.0 |
| 627863 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082397 | 27515 | 1752 | 2021-05-25 00:00:00 | 180 | 1.0 | 0 | 0.0 | No | NaN | 0 | 0 | 2021-11-29 00:00:00 | Same Facility Refill | 0.0 |
| 627864 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082398 | 24628 | 1752 | 2021-05-27 00:00:00 | 90 | 1.0 | 0 | 0.0 | No | NaN | 0 | 0 | 2021-08-30 00:00:00 | Same Facility Refill | 0.0 |
| 627865 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082399 | 27517 | 1752 | 2021-05-25 00:00:00 | 90 | 0.0 | 0 | 1.0 | No | NaN | 0 | 0 | 2021-08-30 00:00:00 | Same Facility Refill | 0.0 |
| 627866 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082400 | 25502 | 1752 | 2021-05-26 00:00:00 | 180 | 1.0 | 0 | 0.0 | No | NaN | 0 | 0 | 2021-11-29 00:00:00 | Same Facility Refill | 0.0 |
| 627867 | Cross River | Ogoja | Ogoja Catholic Maternity Hospital | ART First Line Adult | TDF(300mg)+3TC(300mg)+DTG(50mg) | 4082401 | 23377 | 1752 | 2021-05-26 00:00:00 | 90 | 0.0 | 0 | 1.0 | No | NaN | 0 | 0 | 2021-08-30 00:00:00 | Same Facility Refill | 0.0 |